In [1]:
import pandas as pd
df = pd.read_excel (r'C:\Users\698422\Desktop\Ph.D\Masters Manuscripts\Modeling\Masters Degree Work\Carbonates_microthermometric Data_FINAL FOR BV1.xlsx')
print (df)
                                          Sample Name  \
0                               BV-83.81 Circle 1 FL1   
1       BV-83.81 Circle 2 two very Dark 2-phase FLINC   
2                               BV-83.81 Circle 3 FL1   
3                              BV-83.81 Circle 2  FL4   
4                              BV-83.81 Circle 2  FL5   
5                              BV-83.81 Circle 2  FL6   
6                               BV-83.81 Circle 3 FL1   
7        BV-106.90 Circle 1 vapour-rich 2-phase FLINC   
8                BV-106.90 Circle 1  2-phase FLINC(A)   
9                BV-106.90 Circle 1  2-phase FLINC(B)   
10                 BV-106.90 Circle 1  2-phase FLINC©   
11               BV-106.90 Circle 1  2-phase FLINC(D)   
12                BV-106.90 Circle 1  2-phase FLINC €   
13       BV-106.90 Circle 2 VAPOUR-RICH 2-phase FLINC   
14                BV-106.90 Circle 2 2-phase FLINC(A)   
15                BV-106.90 Circle 2 2-phase FLINC(B)   
16                  BV-106.90 Circle 2 2-phase FLINC©   
17                BV-106.90 Circle 2 2-phase FLINC(D)   
18  BV-352.60 Circle 2 cluster of FLINCs 2-ring FLINC   
19       BV-352.60 Circle 2 3-phase FLINC (2-BUBBLES)   
20             BV-352.60 Circle 2 Cubic 2-phase FLINC   
21  BV-352.60 Circle 2 Rectangular 2-phase FLINC(T...   
22            BV-352.60 Spherical Light 2-phase FLINC   
23                BV-352.60 Triangle-shaped (cluster)   
24               BV-352.60 Circle 4 vapour-rich FLINC   
25                  BV-417.90(1) P1 FL5 2-phase FLINC   
26                  BV-417.90(1) P1 FL6 2-phase FLINC   
27   BV-417.90(1) P2 FL1 2-phase FLINC(Moving bubble)   
28                  BV-417.90(1) P3 FL1 2-phase FLINC   
29          BV-417.90(2) Circle 5 2-phase cubic FLINC   
30                        BV-1046.50 (1) Circle 1 FL1   
31                        BV-1046.50 (1) Circle 1 FL2   
32                        BV-1046.50 (1) Circle 1 FL3   
33  BV-1046.50 (1) Circle 3 Light two-phase FLINC (5)   
34  BV-1046.50 (1) Circle 3 Light two-phase FLINC (6)   
35  BV-1046.50 (1) Circle 3 Light two-phase FLINC (7)   
36    BV-1046.50(1) Circle 3 Dark two-phase FLINC (8)   
37  BV-1046.50 (1) Circle 3 Oval light two-phase F...   
38  BV-1046.50 (1) Circle 2 Dark,Cubic two-phase F...   
39     BV_910_(10)_1_ Circle 2_FL4_Oval 2-phase FLINC   
40         BV_910_(10)_1_ Circle 2_FL9_ 2-phase FLINC   
41    BV_893.90(2) Circle 1_FL1_V-Rich, 2-Phase FLINC   
42           BV_893.90(2) Circle 1_FL2, 2-Phase FLINC   
43           BV_893.90(2) Circle 1_FL4, 2-Phase FLINC   
44           BV_893.90(2) Circle 1_FL5, 2-Phase FLINC   
45    BV_893.90(2) Circle 2_FL1_L-Rich, 2-Phase FLINC   
46           BV_893.90(2) Circle 2_FL2, 2-Phase FLINC   
47           BV_893.90(2) Circle 2_FL3, 2-Phase FLINC   
48           BV_893.90(2) Circle 2_FL4, 2-Phase FLINC   
49           BV_893.90(2) Circle 2_FL5, 2-Phase FLINC   

    TM(melting temperature)  TH(homogenization temperature)  \
0                     -59.3                            27.3   
1                     -56.8                            29.8   
2                     -59.7                            29.9   
3                     -57.8                            27.1   
4                     -58.1                            26.8   
5                     -56.9                            29.3   
6                     -59.7                            29.9   
7                     -56.8                            30.8   
8                     -57.3                            24.9   
9                     -57.6                            23.2   
10                    -56.9                            30.1   
11                    -57.1                            24.9   
12                    -56.9                            30.5   
13                    -56.8                            23.8   
14                    -57.3                            24.2   
15                    -56.9                            30.2   
16                    -57.8                            23.4   
17                    -57.4                            23.9   
18                    -56.8                            30.1   
19                    -57.4                            28.9   
20                    -57.2                            30.4   
21                    -57.2                            28.6   
22                    -57.5                            29.5   
23                    -57.1                            30.1   
24                    -57.1                            30.2   
25                    -57.3                            29.7   
26                    -57.1                            28.5   
27                    -56.9                            28.3   
28                    -56.8                            28.8   
29                    -57.1                            30.0   
30                    -57.1                            30.2   
31                    -56.9                            30.8   
32                    -57.5                            29.4   
33                    -56.9                            29.4   
34                    -57.0                            28.6   
35                    -58.4                            29.2   
36                    -57.1                            28.4   
37                    -56.9                            30.2   
38                    -56.9                            30.3   
39                    -58.4                            18.1   
40                    -59.2                            27.5   
41                    -58.9                            28.9   
42                    -59.6                            27.9   
43                    -58.1                            29.1   
44                    -58.5                            29.4   
45                    -59.6                            27.2   
46                    -57.8                            25.3   
47                    -58.9                            28.9   
48                    -59.2                            27.1   
49                    -58.2                            28.2   

   Form of Homogenization  Density of content (FLUIDS PACKAGE)  \
0                   L+V>L                             0.633195   
1                   L+V>L                             0.602200   
2                   L+V>L                             0.598046   
3                   L+V>L                             0.674385   
4                   L+V>L                             0.674385   
5                   L+V>L                             0.620260   
6                   L+V>L                             0.598046   
7                   L+V>L                             0.538068   
8                   L+V>L                             0.712067   
9                   L+V>L                             0.735836   
10                  L+V>L                             0.580644   
11                  L+V>L                             0.712067   
12                  L+V>L                             0.565873   
13                  L+V>L                             0.727830   
14                  L+V>L                             0.722273   
15                  L+V>L                             0.583935   
16                  L+V>L                             0.733269   
17                  L+V>L                             0.726458   
18                  L+V>L                             0.588963   
19                  L+V>L                             0.632440   
20                  L+V>V                             0.364599   
21                  L+V>L                             0.640672   
22                  L+V>L                             0.613940   
23                  L+V>V                             0.349320   
24                  L+V>L                             0.583935   
25                  L+V>L                             0.606143   
26                  L+V>L                             0.643274   
27                  L+V>L                             0.648294   
28                  L+V>L                             0.635260   
29                  L+V>L                             0.593648   
30                  L+V>L                             0.583935   
31                  L+V>L                             0.538068   
32                  L+V>L                             0.616681   
33                  L+V>L                             0.616681   
34                  L+V>L                             0.640640   
35                  L+V>L                             0.623458   
36                  L+V>L                             0.645814   
37                  L+V>L                             0.583935   
38                  L+V>L                             0.578491   
39                  L+V>L                             0.792829   
40                  L+V>L                             0.657690   
41                  L+V>V                             0.309233   
42                  L+V>L                             0.657696   
43                  L+V>L                             0.626549   
44                  L+V>L                             0.616942   
45                  L+V>L                             0.672523   
46                  L+V>L                             0.705922   
47                  L+V>L                             0.632444   
48                  L+V>L                             0.674503   
49                  L+V>L                             0.650720   

    Density of content  Mole conc.(mol/cm3)  Molar volume(cm3/mol)  \
0             0.670388             0.015236              65.633595   
1             0.601867             0.013679              73.105825   
2             0.597689             0.013584              73.616861   
3             0.674385             0.015327              65.244613   
4             0.680156             0.015458              64.691069   
5             0.620011             0.014091              70.966474   
6             0.597689             0.013584              73.616861   
7             0.536871             0.012202              81.956408   
8             0.711986             0.016181              61.798983   
9             0.735768             0.016722              59.801440   
10            0.588545             0.013376              74.760655   
11            0.711986             0.016181              61.798983   
12            0.565230             0.012846              77.844349   
13            0.727758             0.016540              60.459662   
14            0.722198             0.016414              60.925102   
15            0.583478             0.013261              75.409832   
16            0.733140             0.016662              60.015863   
17            0.726385             0.016509              60.573908   
18            0.588545             0.013376              74.760655   
19            0.632237             0.014369              69.594126   
20            0.365079             0.008297             120.521757   
21            0.640489             0.014557              68.697502   
22            0.614940             0.013976              71.551721   
23            0.347766             0.007904             126.521690   
24            0.586119             0.013321              75.070072   
25            0.607715             0.013812              72.402406   
26            0.644415             0.014646              68.279018   
27            0.649404             0.014759              67.754426   
28            0.636461             0.014465              69.132284   
29            0.595512             0.013534              73.886025   
30            0.583478             0.013261              75.409832   
31            0.536871             0.012202              81.956408   
32            0.616681             0.014015              71.349746   
33            0.618338             0.014053              71.158528   
34            0.641830             0.014587              68.553960   
35            0.624772             0.014199              70.425739   
36            0.646938             0.014703              68.012695   
37            0.586119             0.013321              75.070072   
38            0.580901             0.013202              75.744346   
39            0.793570             0.018036              55.445639   
40            0.667415             0.015169              65.925977   
41            0.308937             0.007021             142.423750   
42            0.658758             0.014972              66.792407   
43            0.627829             0.014269              70.082802   
44            0.618338             0.014053              71.158528   
45            0.673528             0.015307              65.327656   
46            0.706840             0.016065              62.248849   
47            0.633666             0.014402              69.437158   
48            0.675501             0.015352              65.136808   
49            0.651816             0.014814              67.503702   

    Pressure (Mpa)        FIA  
0       356.692176    Primary  
1       294.335667    Primary  
2       290.800668    Primary  
3       360.597811    Primary  
4       366.291824    Primary  
5       310.031419    Primary  
6       290.800668    Primary  
7       242.538438    Primary  
8       398.905890    Primary  
9       424.669576    Primary  
10      283.165402    Primary  
11      398.905890    Primary  
12      264.315454    Primary  
13      415.853779  Secondary  
14      409.818125  Secondary  
15      278.994286  Secondary  
16      421.760767  Secondary  
17      414.357402  Secondary  
18      283.165402    Primary  
19      320.930928    Primary  
20      134.527613  Secondary  
21      328.438075  Secondary  
22      305.587371  Secondary  
23      125.659823    Primary  
24      281.163082    Primary  
25      299.332528    Primary  
26      332.052738    Primary  
27      336.687790  Secondary  
28      324.758120  Secondary  
29      288.970029  Secondary  
30      278.994286    Primary  
31      242.538438    Primary  
32      307.107786    Primary  
33      308.560067    Primary  
34      329.669788    Primary  
35      314.243979    Primary  
36      334.391177    Primary  
37      281.163082    Primary  
38      276.888940    Primary  
39      492.724648  Secondary  
40      353.806875  Secondary  
41      106.940290  Secondary  
42      345.501539  Secondary  
43      316.970329  Secondary  
44      308.560067  Secondary  
45      359.757480    Primary  
46      393.491995    Primary  
47      322.222396    Primary  
48      361.694053    Primary  
49      338.945013    Primary  
In [3]:
df.head(52)
Out[3]:
Sample Name TM(melting temperature) TH(homogenization temperature) Form of Homogenization Density of content (FLUIDS PACKAGE) Density of content Mole conc.(mol/cm3) Molar volume(cm3/mol) Pressure (Mpa) FIA
0 BV-83.81 Circle 1 FL1 -59.3 27.3 L+V>L 0.633195 0.670388 0.015236 65.633595 356.692176 Primary
1 BV-83.81 Circle 2 two very Dark 2-phase FLINC -56.8 29.8 L+V>L 0.602200 0.601867 0.013679 73.105825 294.335667 Primary
2 BV-83.81 Circle 3 FL1 -59.7 29.9 L+V>L 0.598046 0.597689 0.013584 73.616861 290.800668 Primary
3 BV-83.81 Circle 2 FL4 -57.8 27.1 L+V>L 0.674385 0.674385 0.015327 65.244613 360.597811 Primary
4 BV-83.81 Circle 2 FL5 -58.1 26.8 L+V>L 0.674385 0.680156 0.015458 64.691069 366.291824 Primary
5 BV-83.81 Circle 2 FL6 -56.9 29.3 L+V>L 0.620260 0.620011 0.014091 70.966474 310.031419 Primary
6 BV-83.81 Circle 3 FL1 -59.7 29.9 L+V>L 0.598046 0.597689 0.013584 73.616861 290.800668 Primary
7 BV-106.90 Circle 1 vapour-rich 2-phase FLINC -56.8 30.8 L+V>L 0.538068 0.536871 0.012202 81.956408 242.538438 Primary
8 BV-106.90 Circle 1 2-phase FLINC(A) -57.3 24.9 L+V>L 0.712067 0.711986 0.016181 61.798983 398.905890 Primary
9 BV-106.90 Circle 1 2-phase FLINC(B) -57.6 23.2 L+V>L 0.735836 0.735768 0.016722 59.801440 424.669576 Primary
10 BV-106.90 Circle 1 2-phase FLINC© -56.9 30.1 L+V>L 0.580644 0.588545 0.013376 74.760655 283.165402 Primary
11 BV-106.90 Circle 1 2-phase FLINC(D) -57.1 24.9 L+V>L 0.712067 0.711986 0.016181 61.798983 398.905890 Primary
12 BV-106.90 Circle 1 2-phase FLINC € -56.9 30.5 L+V>L 0.565873 0.565230 0.012846 77.844349 264.315454 Primary
13 BV-106.90 Circle 2 VAPOUR-RICH 2-phase FLINC -56.8 23.8 L+V>L 0.727830 0.727758 0.016540 60.459662 415.853779 Secondary
14 BV-106.90 Circle 2 2-phase FLINC(A) -57.3 24.2 L+V>L 0.722273 0.722198 0.016414 60.925102 409.818125 Secondary
15 BV-106.90 Circle 2 2-phase FLINC(B) -56.9 30.2 L+V>L 0.583935 0.583478 0.013261 75.409832 278.994286 Secondary
16 BV-106.90 Circle 2 2-phase FLINC© -57.8 23.4 L+V>L 0.733269 0.733140 0.016662 60.015863 421.760767 Secondary
17 BV-106.90 Circle 2 2-phase FLINC(D) -57.4 23.9 L+V>L 0.726458 0.726385 0.016509 60.573908 414.357402 Secondary
18 BV-352.60 Circle 2 cluster of FLINCs 2-ring FLINC -56.8 30.1 L+V>L 0.588963 0.588545 0.013376 74.760655 283.165402 Primary
19 BV-352.60 Circle 2 3-phase FLINC (2-BUBBLES) -57.4 28.9 L+V>L 0.632440 0.632237 0.014369 69.594126 320.930928 Primary
20 BV-352.60 Circle 2 Cubic 2-phase FLINC -57.2 30.4 L+V>V 0.364599 0.365079 0.008297 120.521757 134.527613 Secondary
21 BV-352.60 Circle 2 Rectangular 2-phase FLINC(T... -57.2 28.6 L+V>L 0.640672 0.640489 0.014557 68.697502 328.438075 Secondary
22 BV-352.60 Spherical Light 2-phase FLINC -57.5 29.5 L+V>L 0.613940 0.614940 0.013976 71.551721 305.587371 Secondary
23 BV-352.60 Triangle-shaped (cluster) -57.1 30.1 L+V>V 0.349320 0.347766 0.007904 126.521690 125.659823 Primary
24 BV-352.60 Circle 4 vapour-rich FLINC -57.1 30.2 L+V>L 0.583935 0.586119 0.013321 75.070072 281.163082 Primary
25 BV-417.90(1) P1 FL5 2-phase FLINC -57.3 29.7 L+V>L 0.606143 0.607715 0.013812 72.402406 299.332528 Primary
26 BV-417.90(1) P1 FL6 2-phase FLINC -57.1 28.5 L+V>L 0.643274 0.644415 0.014646 68.279018 332.052738 Primary
27 BV-417.90(1) P2 FL1 2-phase FLINC(Moving bubble) -56.9 28.3 L+V>L 0.648294 0.649404 0.014759 67.754426 336.687790 Secondary
28 BV-417.90(1) P3 FL1 2-phase FLINC -56.8 28.8 L+V>L 0.635260 0.636461 0.014465 69.132284 324.758120 Secondary
29 BV-417.90(2) Circle 5 2-phase cubic FLINC -57.1 30.0 L+V>L 0.593648 0.595512 0.013534 73.886025 288.970029 Secondary
30 BV-1046.50 (1) Circle 1 FL1 -57.1 30.2 L+V>L 0.583935 0.583478 0.013261 75.409832 278.994286 Primary
31 BV-1046.50 (1) Circle 1 FL2 -56.9 30.8 L+V>L 0.538068 0.536871 0.012202 81.956408 242.538438 Primary
32 BV-1046.50 (1) Circle 1 FL3 -57.5 29.4 L+V>L 0.616681 0.616681 0.014015 71.349746 307.107786 Primary
33 BV-1046.50 (1) Circle 3 Light two-phase FLINC (5) -56.9 29.4 L+V>L 0.616681 0.618338 0.014053 71.158528 308.560067 Primary
34 BV-1046.50 (1) Circle 3 Light two-phase FLINC (6) -57.0 28.6 L+V>L 0.640640 0.641830 0.014587 68.553960 329.669788 Primary
35 BV-1046.50 (1) Circle 3 Light two-phase FLINC (7) -58.4 29.2 L+V>L 0.623458 0.624772 0.014199 70.425739 314.243979 Primary
36 BV-1046.50(1) Circle 3 Dark two-phase FLINC (8) -57.1 28.4 L+V>L 0.645814 0.646938 0.014703 68.012695 334.391177 Primary
37 BV-1046.50 (1) Circle 3 Oval light two-phase F... -56.9 30.2 L+V>L 0.583935 0.586119 0.013321 75.070072 281.163082 Primary
38 BV-1046.50 (1) Circle 2 Dark,Cubic two-phase F... -56.9 30.3 L+V>L 0.578491 0.580901 0.013202 75.744346 276.888940 Primary
39 BV_910_(10)_1_ Circle 2_FL4_Oval 2-phase FLINC -58.4 18.1 L+V>L 0.792829 0.793570 0.018036 55.445639 492.724648 Secondary
40 BV_910_(10)_1_ Circle 2_FL9_ 2-phase FLINC -59.2 27.5 L+V>L 0.657690 0.667415 0.015169 65.925977 353.806875 Secondary
41 BV_893.90(2) Circle 1_FL1_V-Rich, 2-Phase FLINC -58.9 28.9 L+V>V 0.309233 0.308937 0.007021 142.423750 106.940290 Secondary
42 BV_893.90(2) Circle 1_FL2, 2-Phase FLINC -59.6 27.9 L+V>L 0.657696 0.658758 0.014972 66.792407 345.501539 Secondary
43 BV_893.90(2) Circle 1_FL4, 2-Phase FLINC -58.1 29.1 L+V>L 0.626549 0.627829 0.014269 70.082802 316.970329 Secondary
44 BV_893.90(2) Circle 1_FL5, 2-Phase FLINC -58.5 29.4 L+V>L 0.616942 0.618338 0.014053 71.158528 308.560067 Secondary
45 BV_893.90(2) Circle 2_FL1_L-Rich, 2-Phase FLINC -59.6 27.2 L+V>L 0.672523 0.673528 0.015307 65.327656 359.757480 Primary
46 BV_893.90(2) Circle 2_FL2, 2-Phase FLINC -57.8 25.3 L+V>L 0.705922 0.706840 0.016065 62.248849 393.491995 Primary
47 BV_893.90(2) Circle 2_FL3, 2-Phase FLINC -58.9 28.9 L+V>L 0.632444 0.633666 0.014402 69.437158 322.222396 Primary
48 BV_893.90(2) Circle 2_FL4, 2-Phase FLINC -59.2 27.1 L+V>L 0.674503 0.675501 0.015352 65.136808 361.694053 Primary
49 BV_893.90(2) Circle 2_FL5, 2-Phase FLINC -58.2 28.2 L+V>L 0.650720 0.651816 0.014814 67.503702 338.945013 Primary
In [ ]:
df
In [2]:
pip install plotly_express
Requirement already satisfied: plotly_express in c:\users\698422\anaconda3\lib\site-packages (0.4.1)
Requirement already satisfied: pandas>=0.20.0 in c:\users\698422\anaconda3\lib\site-packages (from plotly_express) (1.3.4)
Requirement already satisfied: patsy>=0.5 in c:\users\698422\anaconda3\lib\site-packages (from plotly_express) (0.5.2)
Requirement already satisfied: plotly>=4.1.0 in c:\users\698422\anaconda3\lib\site-packages (from plotly_express) (5.5.0)
Requirement already satisfied: numpy>=1.11 in c:\users\698422\anaconda3\lib\site-packages (from plotly_express) (1.20.3)
Requirement already satisfied: scipy>=0.18 in c:\users\698422\anaconda3\lib\site-packages (from plotly_express) (1.7.1)
Requirement already satisfied: statsmodels>=0.9.0 in c:\users\698422\anaconda3\lib\site-packages (from plotly_express) (0.12.2)
Requirement already satisfied: python-dateutil>=2.7.3 in c:\users\698422\anaconda3\lib\site-packages (from pandas>=0.20.0->plotly_express) (2.8.2)
Requirement already satisfied: pytz>=2017.3 in c:\users\698422\anaconda3\lib\site-packages (from pandas>=0.20.0->plotly_express) (2021.3)
Requirement already satisfied: six in c:\users\698422\anaconda3\lib\site-packages (from patsy>=0.5->plotly_express) (1.16.0)
Requirement already satisfied: tenacity>=6.2.0 in c:\users\698422\anaconda3\lib\site-packages (from plotly>=4.1.0->plotly_express) (8.0.1)
Note: you may need to restart the kernel to use updated packages.
In [3]:
import plotly_express as px  
px.scatter(df,x="TM(melting temperature)", y="TH(homogenization temperature)")
In [22]:
import plotly_express as px  
px.scatter(df_Primary,x="TM(melting temperature)", y="TH(homogenization temperature)")
In [23]:
import plotly_express as px  
px.scatter(df_Secondary,x="TM(melting temperature)", y="TH(homogenization temperature)")
In [4]:
df.shape
Out[4]:
(50, 10)
In [38]:
df.describe()
Out[38]:
TM(melting temperature) TH(homogenization temperature) Density of content (FLUIDS PACKAGE) Density of content Mole conc.(mol/cm3) Molar volume(cm3/mol) Pressure (Mpa)
count 50.000000 50.000000 50.000000 50.000000 50.000000 50.000000 50.000000
mean -57.674000 28.144000 0.621282 0.622927 0.014157 72.791135 319.165619
std 0.919363 2.558472 0.089893 0.090419 0.002055 15.805604 72.097063
min -59.700000 18.100000 0.309233 0.308937 0.007021 55.445639 106.940290
25% -58.175000 27.225000 0.590134 0.590287 0.013416 65.404141 284.616558
50% -57.300000 28.900000 0.629495 0.630033 0.014319 69.838464 318.950629
75% -56.900000 29.975000 0.668816 0.672743 0.015290 74.541997 358.991154
max -56.800000 30.800000 0.792829 0.793570 0.018036 142.423750 492.724648
In [7]:
df_Primary = df[ df['FIA'] == 'Primary' ]
df_Primary
Out[7]:
Sample Name TM(melting temperature) TH(homogenization temperature) Form of Homogenization Density of content (FLUIDS PACKAGE) Density of content Mole conc.(mol/cm3) Molar volume(cm3/mol) Pressure (Mpa) FIA
0 BV-83.81 Circle 1 FL1 -59.3 27.3 L+V>L 0.633195 0.670388 0.015236 65.633595 356.692176 Primary
1 BV-83.81 Circle 2 two very Dark 2-phase FLINC -56.8 29.8 L+V>L 0.602200 0.601867 0.013679 73.105825 294.335667 Primary
2 BV-83.81 Circle 3 FL1 -59.7 29.9 L+V>L 0.598046 0.597689 0.013584 73.616861 290.800668 Primary
3 BV-83.81 Circle 2 FL4 -57.8 27.1 L+V>L 0.674385 0.674385 0.015327 65.244613 360.597811 Primary
4 BV-83.81 Circle 2 FL5 -58.1 26.8 L+V>L 0.674385 0.680156 0.015458 64.691069 366.291824 Primary
5 BV-83.81 Circle 2 FL6 -56.9 29.3 L+V>L 0.620260 0.620011 0.014091 70.966474 310.031419 Primary
6 BV-83.81 Circle 3 FL1 -59.7 29.9 L+V>L 0.598046 0.597689 0.013584 73.616861 290.800668 Primary
7 BV-106.90 Circle 1 vapour-rich 2-phase FLINC -56.8 30.8 L+V>L 0.538068 0.536871 0.012202 81.956408 242.538438 Primary
8 BV-106.90 Circle 1 2-phase FLINC(A) -57.3 24.9 L+V>L 0.712067 0.711986 0.016181 61.798983 398.905890 Primary
9 BV-106.90 Circle 1 2-phase FLINC(B) -57.6 23.2 L+V>L 0.735836 0.735768 0.016722 59.801440 424.669576 Primary
10 BV-106.90 Circle 1 2-phase FLINC© -56.9 30.1 L+V>L 0.580644 0.588545 0.013376 74.760655 283.165402 Primary
11 BV-106.90 Circle 1 2-phase FLINC(D) -57.1 24.9 L+V>L 0.712067 0.711986 0.016181 61.798983 398.905890 Primary
12 BV-106.90 Circle 1 2-phase FLINC € -56.9 30.5 L+V>L 0.565873 0.565230 0.012846 77.844349 264.315454 Primary
18 BV-352.60 Circle 2 cluster of FLINCs 2-ring FLINC -56.8 30.1 L+V>L 0.588963 0.588545 0.013376 74.760655 283.165402 Primary
19 BV-352.60 Circle 2 3-phase FLINC (2-BUBBLES) -57.4 28.9 L+V>L 0.632440 0.632237 0.014369 69.594126 320.930928 Primary
23 BV-352.60 Triangle-shaped (cluster) -57.1 30.1 L+V>V 0.349320 0.347766 0.007904 126.521690 125.659823 Primary
24 BV-352.60 Circle 4 vapour-rich FLINC -57.1 30.2 L+V>L 0.583935 0.586119 0.013321 75.070072 281.163082 Primary
25 BV-417.90(1) P1 FL5 2-phase FLINC -57.3 29.7 L+V>L 0.606143 0.607715 0.013812 72.402406 299.332528 Primary
26 BV-417.90(1) P1 FL6 2-phase FLINC -57.1 28.5 L+V>L 0.643274 0.644415 0.014646 68.279018 332.052738 Primary
30 BV-1046.50 (1) Circle 1 FL1 -57.1 30.2 L+V>L 0.583935 0.583478 0.013261 75.409832 278.994286 Primary
31 BV-1046.50 (1) Circle 1 FL2 -56.9 30.8 L+V>L 0.538068 0.536871 0.012202 81.956408 242.538438 Primary
32 BV-1046.50 (1) Circle 1 FL3 -57.5 29.4 L+V>L 0.616681 0.616681 0.014015 71.349746 307.107786 Primary
33 BV-1046.50 (1) Circle 3 Light two-phase FLINC (5) -56.9 29.4 L+V>L 0.616681 0.618338 0.014053 71.158528 308.560067 Primary
34 BV-1046.50 (1) Circle 3 Light two-phase FLINC (6) -57.0 28.6 L+V>L 0.640640 0.641830 0.014587 68.553960 329.669788 Primary
35 BV-1046.50 (1) Circle 3 Light two-phase FLINC (7) -58.4 29.2 L+V>L 0.623458 0.624772 0.014199 70.425739 314.243979 Primary
36 BV-1046.50(1) Circle 3 Dark two-phase FLINC (8) -57.1 28.4 L+V>L 0.645814 0.646938 0.014703 68.012695 334.391177 Primary
37 BV-1046.50 (1) Circle 3 Oval light two-phase F... -56.9 30.2 L+V>L 0.583935 0.586119 0.013321 75.070072 281.163082 Primary
38 BV-1046.50 (1) Circle 2 Dark,Cubic two-phase F... -56.9 30.3 L+V>L 0.578491 0.580901 0.013202 75.744346 276.888940 Primary
45 BV_893.90(2) Circle 2_FL1_L-Rich, 2-Phase FLINC -59.6 27.2 L+V>L 0.672523 0.673528 0.015307 65.327656 359.757480 Primary
46 BV_893.90(2) Circle 2_FL2, 2-Phase FLINC -57.8 25.3 L+V>L 0.705922 0.706840 0.016065 62.248849 393.491995 Primary
47 BV_893.90(2) Circle 2_FL3, 2-Phase FLINC -58.9 28.9 L+V>L 0.632444 0.633666 0.014402 69.437158 322.222396 Primary
48 BV_893.90(2) Circle 2_FL4, 2-Phase FLINC -59.2 27.1 L+V>L 0.674503 0.675501 0.015352 65.136808 361.694053 Primary
49 BV_893.90(2) Circle 2_FL5, 2-Phase FLINC -58.2 28.2 L+V>L 0.650720 0.651816 0.014814 67.503702 338.945013 Primary
In [6]:
df_Secondary = df[ df['FIA'] == 'Secondary' ]
df_Secondary
Out[6]:
Sample Name TM(melting temperature) TH(homogenization temperature) Form of Homogenization Density of content (FLUIDS PACKAGE) Density of content Mole conc.(mol/cm3) Molar volume(cm3/mol) Pressure (Mpa) FIA
13 BV-106.90 Circle 2 VAPOUR-RICH 2-phase FLINC -56.8 23.8 L+V>L 0.727830 0.727758 0.016540 60.459662 415.853779 Secondary
14 BV-106.90 Circle 2 2-phase FLINC(A) -57.3 24.2 L+V>L 0.722273 0.722198 0.016414 60.925102 409.818125 Secondary
15 BV-106.90 Circle 2 2-phase FLINC(B) -56.9 30.2 L+V>L 0.583935 0.583478 0.013261 75.409832 278.994286 Secondary
16 BV-106.90 Circle 2 2-phase FLINC© -57.8 23.4 L+V>L 0.733269 0.733140 0.016662 60.015863 421.760767 Secondary
17 BV-106.90 Circle 2 2-phase FLINC(D) -57.4 23.9 L+V>L 0.726458 0.726385 0.016509 60.573908 414.357402 Secondary
20 BV-352.60 Circle 2 Cubic 2-phase FLINC -57.2 30.4 L+V>V 0.364599 0.365079 0.008297 120.521757 134.527613 Secondary
21 BV-352.60 Circle 2 Rectangular 2-phase FLINC(T... -57.2 28.6 L+V>L 0.640672 0.640489 0.014557 68.697502 328.438075 Secondary
22 BV-352.60 Spherical Light 2-phase FLINC -57.5 29.5 L+V>L 0.613940 0.614940 0.013976 71.551721 305.587371 Secondary
27 BV-417.90(1) P2 FL1 2-phase FLINC(Moving bubble) -56.9 28.3 L+V>L 0.648294 0.649404 0.014759 67.754426 336.687790 Secondary
28 BV-417.90(1) P3 FL1 2-phase FLINC -56.8 28.8 L+V>L 0.635260 0.636461 0.014465 69.132284 324.758120 Secondary
29 BV-417.90(2) Circle 5 2-phase cubic FLINC -57.1 30.0 L+V>L 0.593648 0.595512 0.013534 73.886025 288.970029 Secondary
39 BV_910_(10)_1_ Circle 2_FL4_Oval 2-phase FLINC -58.4 18.1 L+V>L 0.792829 0.793570 0.018036 55.445639 492.724648 Secondary
40 BV_910_(10)_1_ Circle 2_FL9_ 2-phase FLINC -59.2 27.5 L+V>L 0.657690 0.667415 0.015169 65.925977 353.806875 Secondary
41 BV_893.90(2) Circle 1_FL1_V-Rich, 2-Phase FLINC -58.9 28.9 L+V>V 0.309233 0.308937 0.007021 142.423750 106.940290 Secondary
42 BV_893.90(2) Circle 1_FL2, 2-Phase FLINC -59.6 27.9 L+V>L 0.657696 0.658758 0.014972 66.792407 345.501539 Secondary
43 BV_893.90(2) Circle 1_FL4, 2-Phase FLINC -58.1 29.1 L+V>L 0.626549 0.627829 0.014269 70.082802 316.970329 Secondary
44 BV_893.90(2) Circle 1_FL5, 2-Phase FLINC -58.5 29.4 L+V>L 0.616942 0.618338 0.014053 71.158528 308.560067 Secondary
In [10]:
df_Primary.describe()
Out[10]:
TM(melting temperature) TH(homogenization temperature) Density of content (FLUIDS PACKAGE) Density of content Mole conc.(mol/cm3) Molar volume(cm3/mol) Pressure (Mpa)
count 33.000000 33.000000 33.000000 33.000000 33.000000 33.000000 33.000000
mean -57.639394 28.642424 0.618575 0.620505 0.014102 72.084836 314.364360
std 0.946685 1.919640 0.068843 0.069742 0.001585 11.226697 56.565319
min -59.700000 23.200000 0.349320 0.347766 0.007904 59.801440 125.659823
25% -58.100000 27.300000 0.583935 0.588545 0.013376 65.633595 283.165402
50% -57.100000 29.300000 0.620260 0.620011 0.014091 70.966474 310.031419
75% -56.900000 30.100000 0.650720 0.670388 0.015236 74.760655 356.692176
max -56.800000 30.800000 0.735836 0.735768 0.016722 126.521690 424.669576
In [9]:
df_Secondary.describe()
Out[9]:
TM(melting temperature) TH(homogenization temperature) Density of content (FLUIDS PACKAGE) Density of content Mole conc.(mol/cm3) Molar volume(cm3/mol) Pressure (Mpa)
count 17.000000 17.000000 17.000000 17.000000 17.000000 17.000000 17.000000
mean -57.741176 27.176471 0.626536 0.627629 0.014264 74.162187 328.485712
std 0.888157 3.342067 0.123386 0.123588 0.002809 22.582323 96.848981
min -59.600000 18.100000 0.309233 0.308937 0.007021 55.445639 106.940290
25% -58.400000 24.200000 0.613940 0.614940 0.013976 60.925102 305.587371
50% -57.400000 28.600000 0.640672 0.640489 0.014557 68.697502 328.438075
75% -57.100000 29.400000 0.722273 0.722198 0.016414 71.551721 409.818125
max -56.800000 30.400000 0.792829 0.793570 0.018036 142.423750 492.724648
In [7]:
import matplotlib as mpl
import matplotlib.pyplot as plt
import numpy as np
# if using a Jupyter notebook, includue:
%matplotlib inline
In [9]:
# Histogram with bins=30

df.hist(bins=30);
In [49]:
len(df)
Out[49]:
50
In [24]:
#define bine edges
bin_edges = [18,20,22,24,26,28,30,32]
# Histogram of 'TH(homogenization temperature)' column
df.hist(column='TH(homogenization temperature)',
       bins=bin_edges,
         density=False,
         histtype='bar',
         color='b',
         edgecolor='k')
plt.xlabel('TH(homogenization temperature)')
plt.ylabel('Count');
In [30]:
#define bine edges
bin_edges = [-60.0,-59.5,-59.0,-58.5,-58.0,-57.5,-57.0]
# Histogram of 'TM(melting temperature)' column
df.hist(column='TM(melting temperature)',        
        bins=bin_edges,
        histtype='bar',
         color='b',
         edgecolor='k')
plt.xlabel('TM(melting temperature)')
plt.ylabel('Count');
In [11]:
sns.pairplot(data=df, hue="FIA")
Out[11]:
<seaborn.axisgrid.PairGrid at 0x225ca610cd0>
In [19]:
fig,ax = plt.subplots()
sns.scatterplot(data=df, hue='FIA', x='TH(homogenization temperature)', y='TM(melting temperature)')
plt.legend(loc=2)
plt.savefig('scatter.png')
plt.show()
In [12]:
sns.histplot(data=df, x="TH(homogenization temperature)", hue="FIA")
Out[12]:
<AxesSubplot:xlabel='TH(homogenization temperature)', ylabel='Count'>
In [13]:
sns.histplot(data=df, x="TH(homogenization temperature)", hue="FIA", multiple="stack")
Out[13]:
<AxesSubplot:xlabel='TH(homogenization temperature)', ylabel='Count'>
In [14]:
sns.histplot(data=df, x="TM(melting temperature)", hue="FIA")
Out[14]:
<AxesSubplot:xlabel='TM(melting temperature)', ylabel='Count'>
In [15]:
sns.histplot(data=df, x="TM(melting temperature)", hue="FIA", multiple="stack")
Out[15]:
<AxesSubplot:xlabel='TM(melting temperature)', ylabel='Count'>
In [16]:
 sns.histplot(data=df, x="Molar volume(cm3/mol)", hue="FIA")
Out[16]:
<AxesSubplot:xlabel='Molar volume(cm3/mol)', ylabel='Count'>
In [17]:
sns.histplot(data=df, x="Molar volume(cm3/mol)", hue="FIA",multiple="stack")
Out[17]:
<AxesSubplot:xlabel='Molar volume(cm3/mol)', ylabel='Count'>
In [18]:
df.dtypes
Out[18]:
Sample Name                             object
TM(melting temperature)                float64
TH(homogenization temperature)         float64
Form of Homogenization                  object
Density of content (FLUIDS PACKAGE)    float64
Density of content                     float64
Mole conc.(mol/cm3)                    float64
Molar volume(cm3/mol)                  float64
Pressure (Mpa)                         float64
FIA                                     object
dtype: object
In [20]:
import os
import pandas as pd
Microthermometric_Data_BV_Aqueous = os.path.join('data', 'Carbonates_microthermometric Data_FINAL FOR BV1.xlsx')
results_df = pd.read_excel(r'C:\Users\698422\Desktop\Ph.D\Masters Manuscripts\Modeling\Carbonates_microthermometric Data_FINAL FOR BV1.xlsx')
xdata = results_df['TH(homogenization temperature)']  
ydata = results_df['TM(melting temperature)'] 
from scipy import stats
slope, intercept, r_value, p_value, std_err = stats.linregress(xdata, ydata)

import seaborn as sns
sns.regplot(x = xdata, y = ydata)
Out[20]:
<AxesSubplot:xlabel='TH(homogenization temperature)', ylabel='TM(melting temperature)'>
In [1]:
pip install nbconvert
Requirement already satisfied: nbconvert in c:\users\698422\anaconda3\lib\site-packages (6.1.0)
Requirement already satisfied: bleach in c:\users\698422\anaconda3\lib\site-packages (from nbconvert) (4.0.0)
Requirement already satisfied: pandocfilters>=1.4.1 in c:\users\698422\anaconda3\lib\site-packages (from nbconvert) (1.4.3)
Requirement already satisfied: nbclient<0.6.0,>=0.5.0 in c:\users\698422\anaconda3\lib\site-packages (from nbconvert) (0.5.3)
Requirement already satisfied: traitlets>=5.0 in c:\users\698422\anaconda3\lib\site-packages (from nbconvert) (5.1.0)
Requirement already satisfied: mistune<2,>=0.8.1 in c:\users\698422\anaconda3\lib\site-packages (from nbconvert) (0.8.4)
Requirement already satisfied: defusedxml in c:\users\698422\anaconda3\lib\site-packages (from nbconvert) (0.7.1)
Requirement already satisfied: nbformat>=4.4 in c:\users\698422\anaconda3\lib\site-packages (from nbconvert) (5.1.3)
Requirement already satisfied: jinja2>=2.4 in c:\users\698422\anaconda3\lib\site-packages (from nbconvert) (2.11.3)
Requirement already satisfied: entrypoints>=0.2.2 in c:\users\698422\anaconda3\lib\site-packages (from nbconvert) (0.3)
Requirement already satisfied: jupyterlab-pygments in c:\users\698422\anaconda3\lib\site-packages (from nbconvert) (0.1.2)
Requirement already satisfied: testpath in c:\users\698422\anaconda3\lib\site-packages (from nbconvert) (0.5.0)
Requirement already satisfied: jupyter-core in c:\users\698422\anaconda3\lib\site-packages (from nbconvert) (4.8.1)
Requirement already satisfied: pygments>=2.4.1 in c:\users\698422\anaconda3\lib\site-packages (from nbconvert) (2.10.0)
Requirement already satisfied: MarkupSafe>=0.23 in c:\users\698422\anaconda3\lib\site-packages (from jinja2>=2.4->nbconvert) (1.1.1)
Requirement already satisfied: async-generator in c:\users\698422\anaconda3\lib\site-packages (from nbclient<0.6.0,>=0.5.0->nbconvert) (1.10)
Requirement already satisfied: jupyter-client>=6.1.5 in c:\users\698422\anaconda3\lib\site-packages (from nbclient<0.6.0,>=0.5.0->nbconvert) (6.1.12)
Requirement already satisfied: nest-asyncio in c:\users\698422\anaconda3\lib\site-packages (from nbclient<0.6.0,>=0.5.0->nbconvert) (1.5.1)
Requirement already satisfied: pyzmq>=13 in c:\users\698422\anaconda3\lib\site-packages (from jupyter-client>=6.1.5->nbclient<0.6.0,>=0.5.0->nbconvert) (22.2.1)
Requirement already satisfied: tornado>=4.1 in c:\users\698422\anaconda3\lib\site-packages (from jupyter-client>=6.1.5->nbclient<0.6.0,>=0.5.0->nbconvert) (6.1)
Requirement already satisfied: python-dateutil>=2.1 in c:\users\698422\anaconda3\lib\site-packages (from jupyter-client>=6.1.5->nbclient<0.6.0,>=0.5.0->nbconvert) (2.8.2)
Requirement already satisfied: pywin32>=1.0 in c:\users\698422\anaconda3\lib\site-packages (from jupyter-core->nbconvert) (228)
Requirement already satisfied: jsonschema!=2.5.0,>=2.4 in c:\users\698422\anaconda3\lib\site-packages (from nbformat>=4.4->nbconvert) (3.2.0)
Requirement already satisfied: ipython-genutils in c:\users\698422\anaconda3\lib\site-packages (from nbformat>=4.4->nbconvert) (0.2.0)
Requirement already satisfied: six>=1.11.0 in c:\users\698422\anaconda3\lib\site-packages (from jsonschema!=2.5.0,>=2.4->nbformat>=4.4->nbconvert) (1.16.0)
Requirement already satisfied: attrs>=17.4.0 in c:\users\698422\anaconda3\lib\site-packages (from jsonschema!=2.5.0,>=2.4->nbformat>=4.4->nbconvert) (21.2.0)
Requirement already satisfied: setuptools in c:\users\698422\anaconda3\lib\site-packages (from jsonschema!=2.5.0,>=2.4->nbformat>=4.4->nbconvert) (58.0.4)
Requirement already satisfied: pyrsistent>=0.14.0 in c:\users\698422\anaconda3\lib\site-packages (from jsonschema!=2.5.0,>=2.4->nbformat>=4.4->nbconvert) (0.18.0)
Requirement already satisfied: packaging in c:\users\698422\anaconda3\lib\site-packages (from bleach->nbconvert) (21.0)
Requirement already satisfied: webencodings in c:\users\698422\anaconda3\lib\site-packages (from bleach->nbconvert) (0.5.1)
Requirement already satisfied: pyparsing>=2.0.2 in c:\users\698422\anaconda3\lib\site-packages (from packaging->bleach->nbconvert) (3.0.4)
Note: you may need to restart the kernel to use updated packages.
In [ ]: